Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WalletShareID (PK) | Token ID to identify an instance of a WalletShareEstimate entity type. | ID_WLLT_SHR | Identity | integer | |
CustomerID (FK) | A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. | ID_CT | Identity | integer | KeyCustomer(PA_KY_CT) |
ReportingPeriodID (FK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
MerchandiseHierarchyGroupID (FK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | MerchandiseHierarchyGroup(CO_MRHRC_GP) |
CreateDateTime | Date and time this WalletShareEstimate is created. | DT_CRT | AuditDateTime | datetime | |
SourceDataDescription | A description of where this information came from. For example the US Census, UK Census, etc. It's purpose is to identify the data source used to derive the wallet share estimate. | DE_SRC_DAT | DescriptionShort | varchar(255) | |
EstimationMethodologyNarrative | A short narrative describing how the wallet share estimate is derived. | NA_ESTM_MTH | DescriptionNarrative | varchar(4000) | |
EstimatedWalletAmount | Estimated monetary value of the total wallet amount a customer spends on a given categroy of item for a given reporting period. This is the amount used as the divisor (the cumulative retailer's customer-category-reporting period sales is the dividend) in determning the percentage of wallet a retailer "owns". | MO_ESTM_WLLT | Money | decimal(16,5) | |
EffectiveDate | Date this wallet share estimate is usable. | DC_EF | EffectiveDate | date | |
ExpirationDate | Date this wallet share estimate is no longer usable. | DC_EP | ExpirationDate | date | |
StatusCode | Current status of the wallet share estimate. Valid values are: A- Active I - Inactive | CD_STS | Code2Status | char(2) | |
RetailVerticalCategoryCode (FK) | Category code for retail vertical (e.g. GROCERY, HME_IMPRVMT, APPRAL, AUTOPARTS, etc.) | CD_RTL_VRTL_CTGY | Code | varchar(20) | RetailVerticalReference(LU_RTL_VRTL_RFC) |